package kuonjisai.swing.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class J26_SungJukDAO {
	
	private String DRV = "oracle.jdbc.driver.OracleDriver";
	private String URL = "jdbc:oracle:thin:cjhmasterola/cjhmasterola@112.216.253.125:1521:xe";
	private String insertSQL = " insert into sungjuk values ( exam.nextval, ?, ?, ?, ?, ? ,?, ?, sysdate )";
	
	protected Connection openDatabase() {
		try{
		Class.forName( DRV );
		return DriverManager.getConnection( URL );
		} catch ( Exception e  ){
			e.printStackTrace();
		}
		
		return  null;
	}
	
	
	public boolean insertSungJuk ( J26_SungJukVO sj ){
		boolean result = false;
		Connection conn = null;
		PreparedStatement pstmt = null;
		
		try {
			conn = openDatabase();
			pstmt = conn.prepareStatement(insertSQL);
			pstmt.setString(1, sj.getName() );
			pstmt.setString(2, sj.getKor() );
			pstmt.setString(3, sj.getEng() );
			pstmt.setString(4, sj.getMat() );
			pstmt.setString(5, sj.getTot() );
			pstmt.setString(6, sj.getAvg() );
			pstmt.setString(7, sj.getGrd() );
			
			pstmt.executeUpdate();
			
			result = true;
		}catch( Exception ex){
			
			ex.printStackTrace();
			
		}finally{
			closeDatabase(conn, pstmt, null);
			
		}
		
		
		
		
		return result;
		
	}
	
	
	protected void closeDatabase( Connection c, PreparedStatement p, ResultSet r ){
		if ( r != null ) try { r.close(); r = null; } catch ( Exception ex ) {};
		if ( p != null ) try { p.close(); p = null; } catch ( Exception ex ) {};
		if ( c != null ) try { c.close(); c = null; } catch ( Exception ex ) {};
		
		
	}
	
} // class
